Bank Statement Import

Bank Statement import in system

Navigation: Payroll Administrator/ Home/ Payroll Sheets/ Payroll Payments Extract Buffer

All payroll payments made from Internet Bank, need to be linked with relevant Payroll Document in system.

Process Starts with exporting Bank Statement from Bank and importing it in system, via "Payroll Payments Extraxt Buffer" button, in Payroll Sheet:

Step 1. Import Payroll Payment

Click "Payroll Sheet Card" → "Payroll Payment Extraxt Buffer" → "New" → "Import Payroll Payments" → Select file → Click "OK"

Step 2. Payroll Payments Check

System looks back the Payment Date at the Posted Payroll Document (reversed, correction=false), for each calculates the "Payroll Amount" - "Posted Amount" by Wage|Bonus lines, compares the resulting value with Amount, it should be less and as close as possible to Amount. System checks in the Payroll Sheet Line if there are already lines for such a Posted Payroll Document, if so, then reduces the result by the sum of such lines.

System fills the found document to Posted Payroll Document No. If a suitable document is not found, then generates Error message and colors the line in red.

System checks Payroll Period. If in Wage Period (from Payroll Sheet) Employee doesn’t have Payroll Document, but this Employee is in the buffer, System generates error message: “There is no Posted Payroll Document”

Step 3. Transfer to Pay Sheet

After Transferring lines from buffer to Payroll Sheet, lines are created in Document. System checks that Amount turned out = Amount, which was in the buffer, if the amount turned out is less, then leaves the line in the buffer with difference, if not, then deletes it in buffer.